Aleno Token Report PoC

This POC is done on ERC20 contracts where we analyse the token holders. This same analysis can be done on any contract type to analyze the users and can be automated

Token general information

Token name :  Stake DAO Token
Token symbol :  SDT
Token ID 24924
Statistics computed 2022-10-21 17:52:30
 Price 0.40465805
total dex volume 92 M SDT
total dex usd volume 269 M$

Stake DAO Token is swapped in 5 pools on 3 different exchanges

address	protocol_id	swap_count	usd_volume
0xc465c0a16228ef6fe1bf29c04fdb04bb797fd537	Uniswap v2	36757	224606245.000000
0x22def8cf4e481417cb014d9dc64975ba12e3a184	SushiSwap	7991	47924458.000000
0xa87ba0a33aca750492b5a1100701ce2254a7d9c9	Uniswap v3	117	22391.751000
0x28ff0df1288cb5ab19a8fadf6a425c97a2b81c1b	Uniswap v2	21	8719.719500
0x9c9b9b1ef91b2fa5c8f3bc5b6f375d69dc49f55c	Uniswap v2	3	421.293870

Price evolution

Accounts analysis

13406 have been exposed to Stake DAO Token through decentralized exchanges on ethereum
3848 accounts have bought Stake DAO Token on decentralized exchanges and have a non null balance
3909 are currently holding Stake DAO Token

At the moment we can analyse 3 types of players:

• All the addresses that interacted with the token through DEXES
• All the addresses that bought some tokens though DEXES without selling them
• All the "True" token holders

Holdings distribution without extreme values

1392 holders have more than 100 SDT

Some dapps offer a tiering systems for they users that enables different perks. The following analysis could be split into the analysis of these different tiers to display major differencies between those groups.

Holders Description

Comparer avec les gens qui swap le token utiliser les balances etherscan Regarder l'activité de swapping labeliser non swapper address labeliser passif holders plutot que simple holder

There were 1071 active accounts last month

Labeling definition can be improved. What other labels should we add ?

We could add a graph showing the distribution of the age of the users

Some accounts are not labeled since they don't apear in our database. Should we add them ?

Some addresses might have transferred their tokens to other addresses or other chains so holders are not 100% exact. Tracking those transfers could be added for a slight improvement. Current analysis is quite representative when empirically verifying results

We could also cludter the related accounts that have done some inner transfers

This analysis could be handled on all the addresses that interacted with the tokens and not only the current holders

From here bots are removed from the analysis

Removing 0.29% bot accounts from the analysis

Should We add the distribution only for users ? Or most precisely active users ?

Show recent holders interaction (4 weeks old)

Recent asset swapped

Notable recent tokens swaped by Stake DAO Token holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']

address	name	symbol	swap_count	total_dollar_volume
0x853d955acef822db058eb8505911ed77f175b99e	Frax	FRAX	121	2337418.919182
0x767fe9edc9e0df98e07454847909b5e959d7ca0e	Illuvium	ILV	31	395273.164450
0x9813037ee2218799597d83d4a5b6f3b6778218d9	BONE SHIBASWAP	BONE	95	274443.356127
0xba8a621b4a54e61c442f5ec623687e2a942225ef	Sandclock	QUARTZ	20	254784.695880
0x1a7e4e63778b4f12a199c062f3efdd288afcbce8	agEUR	agEUR	37	246129.560706
0x5a98fcbea516cf06857215779fd812ca3bef1b32	Lido DAO Token	LDO	27	241471.030284
0xf1f955016ecbcd7321c7266bccfb96c68ea5e49b	Rally	RLY	37	209624.407206
0xc18360217d8f7ab5e7c516566761ea12ce7f9d72	Ethereum Name Service	ENS	28	192515.433109
0x9d71ce49ab8a0e6d2a1e7bfb89374c9392fd6804	NvirWorld	Nvir	62	175667.578558
0x66761fa41377003622aee3c7675fc7b5c1c2fac5	Clearpool	CPOOL	76	168766.096040
0xd084944d3c05cd115c09d072b9f44ba3e0e45921	Manifold Finance	FOLD	46	165611.505800
0x5f98805a4e8be255a32880fdec7f6728c6568ba0	LUSD Stablecoin	LUSD	31	163470.531450
0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0	Frax Share	FXS	54	155872.968286
0x0cba60ca5ef4d42f92a5070a8fedd13be93e2861	The Protocol	THE	69	146192.839314
0x3aada3e213abf8529606924d8d1c55cbdc70bf74	XMON	XMON	28	131602.833565
0x73968b9a57c6e53d41345fd57a6e6ae27d6cdb2f	Stake DAO Token	SDT	92	114832.243614
0x12b6893ce26ea6341919fe289212ef77e51688c8	Tamadoge	TAMA	61	114812.171580
0x57ab1ec28d129707052df4df418d58a2d46d5f51	Synth sUSD	sUSD	10	109522.028043
0xc5a9bc46a7dbe1c6de493e84a18f02e70e2c5a32	WORLD CUP INU	WCI	21	107829.735672
0xfe2e637202056d30016725477c5da089ab0a043a	StakeWise Staked ETH2	sETH2	3	107739.089985

Do we need to analyze recent swaps more in depth ?

Recent contract interaction by removing ERC20 Tokens

to_address	transaction_count	unique_account_count	label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	1998	282	Uniswap V3 Router
0x00000000006c3852cbef3e08e8df289169ede581	749	128	Seaport 1.1
0x1111111254fb6c44bac0bed2854e76f90643097d	2344	115	1inch v4 Router
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	207	79	SushiSwap Router
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	397	74	Paraswap Augustus v5
0xdef1c0ded9bec7f1a1670819833240f027b25eff	467	66	0x: Exchange Proxy
0x633120100e108f03ace79d6c78aac9a56db1be0f	70	55	Stake DAO Claim Rewards
0x881d40237659c251811cec9c364ef91dc08d300c	123	53	Metamask Router
0xba12222222228d8ba445958a75a0704d566bf2c8	102	52	Balancer Vault
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f	55	44	Arbitrum: Delayed Inbox
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	318	44	Aave: Lending Pool V2
0xa0c68c638235ee32657e8f720a23cec1bfc77c77	68	42	Polygon Matic Bridge
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5	327	41	ENS: ETH Registrar Controller
0xf403c135812408bfbe8713b5a23a04b3d48aae31	66	38	Convex Finance: Booster
0xdd49a93fdcae579ae50b4b9923325e9e335ec82b	53	36	Convex: Claim Zap
0x72a19342e8f1838460ebfccef09f6585e32db86e	66	35	Vote Locked Convex Token (vlCVX)
0x7893bbb46613d7a4fbcc31dab4c9b823ffee1026	105	33	bribe.crv.finance: Gauge Bribe V2
0x03e34b085c52985f6a5d27243f20c84bddc01db4	39	32	nan
0x3fe65692bfcd0e6cf84cb1e7d24108e434a7587e	50	31	Convex Finance: cvxCRV Rewards
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	44	31	Curve.fi: DAI/USDC/USDT Pool
0x6e99ee539594fa6a621a29022aa50ae7f32f14bb	30	30	nan
0x7f50786a0b15723d741727882ee99a0bf34e3466	47	25	Stake DAO sdCRV Gauge
0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2	46	25	Gem: GemSwap 2
0xf7b55c3732ad8b2c2da7c24f30a69f55c54fb717	54	24	Curve.fi Factory Plain Pool: sdCRV (sdCRVCRV-f)
0x3fa73f1e5d8a792c80f426fc8f84fbf7ce9bbcac	39	23	Aura Locker: vlAURA
0x5de4ef4879f4fe3bbadf2227d2ac5d0e2d76c895	63	22	nan
0x469788fe6e9e9681c6ebf3bf78e7fd26fc015446	38	22	Snapshot: Delegation
0xb8901acb165ed027e32754e0ffe830802919727f	26	21	Hop Protocol Bridge
0xa79828df1850e8a3a3064576f380d90aecdd3359	31	20	Curve Finance: 3Pool Deposit Zap
0xd658a338613198204dca1143ac3f01a722b5d94a	33	19	nan
0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef	28	19	nan
0x2f50d538606fa9edd2b11e2446beb18c9d5846bb	36	18	nan
0xfea5e213bbd81a8a94d0e1edb09dbd7ceab61e1c	23	18	Stake DAO: MasterChef

All time User interaction

Most swapped assets all time by token holders

Notable tokens held by Stake DAO Token holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']

unique_account_count	name	symbol	price	usd_exposure	address
2552	Stake DAO Token	SDT	0.404658	4898308.857835	0x73968b9a57c6e53d41345fd57a6e6ae27d6cdb2f
823	Curve DAO Token	CRV	0.882844	32995909.052379	0xd533a949740bb3306d119cc777fa900ba034cd52
678	Badger	BADGER	3.170393	6197651.797093	0x3472a5a71965499acd81997a54bba8d852c6e53d
595	1INCH Token	1INCH	0.557987	1024453.315581	0x111111111117dc0aa78b770fa6a738034120c302
498	yearn.finance	YFI	7447.290500	31843790.455261	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e
490	Synthetix Network Token	SNX	2.177492	5587181.711651	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f
484	Convex Token	CVX	4.973902	39131676.794327	0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b
444	Olympus	OHM	54.236073	5162158.799765	0x383518188c0c6d7730d91b2c03a03c837814a899
443	ChainLink Token	LINK	6.689694	7302568.547904	0x514910771af9ca656af840dff83e8264ecf986ca
415	Aave Token	AAVE	82.044920	20532348.572686	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9
412	Compound	COMP	48.926340	2800654.149038	0xc00e94cb662c3520282e6f5717214004a7f26888
395	Frax	FRAX	0.999485	153767584.988908	0x853d955acef822db058eb8505911ed77f175b99e
356	ROOK	ROOK	26.524168	2235142.269414	0xfa5047c9c78b8877af97bdcb85db743fd7313d4a
353	Synth sUSD	sUSD	0.997233	16476016.344086	0x57ab1ec28d129707052df4df418d58a2d46d5f51
352	Lido DAO Token	LDO	1.509240	13900903.397693	0x5a98fcbea516cf06857215779fd812ca3bef1b32
352	Frax Share	FXS	6.176063	29113694.957651	0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0
342	DEXTools	DEXT	0.109445	1254785.173236	0xfb7b4564402e5500db5bb6d63ae671302777c75a
340	Wrapped MIR Token	MIR	0.197330	250274.662289	0x09a3ecafa817268f77be1283176b946c4ff2e608
338	PickleToken	PICKLE	1.247716	1606270.966607	0x429881672b9ae42b8eba0e26cd9c73711b891ca5
337	Parsiq Token	PRQ	0.097031	253067.329745	0x362bc847a3a9637d3af6624eec853618a43ed7d2

• This Could be improved by labeling tokens category such as (DeFi, P2E, Stables etc ...)
• Same table can be done with all accounts that interacted with the token, not only the current holders

Most used contracts by holders by removing ERC20 Tokens

to_address	transaction_count	unique_account_count	label
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f	39952	1643	SushiSwap Router
0xe592427a0aece92de3edee1f18e0157c05861564	16792	1634	Uniswap V3 Router
0x881d40237659c251811cec9c364ef91dc08d300c	11198	1368	Metamask Router
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45	16853	1338	Uniswap V3 Router
0xdef1c0ded9bec7f1a1670819833240f027b25eff	34771	1288	0x: Exchange Proxy
0xa0c68c638235ee32657e8f720a23cec1bfc77c77	10064	1146	Polygon Matic Bridge
0x7be8076f4ea4a4ad08075c2508e481d6c946d12b	48447	1066	Opensea Wyvern exchange V1
0xa5409ec958c83c3f309868babaca7c86dcb077c1	984	951	Opensea Registry
0x22ba8eeac5bddf7b5a298d2169a24c6f9e12baa0	938	919	Badger Hunt, by Stake DAO
0x090d4613473dee047c3f2706764f49e0821d256e	1090	918	Uniswap token Distributor
0x11111112542d85b3ef69ae05771c2dccff4faa26	17313	867	1inch v3
0x111111125434b319222cdbf8c261674adb56f3ae	13579	861	1inch Network V2
0xfea5e213bbd81a8a94d0e1edb09dbd7ceab61e1c	7225	813	Stake DAO: MasterChef
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f	1898	802	Arbitrum: Delayed Inbox
0x3e66b66fd1d0b02fda6c811da9e0547970db2f21	5156	771	Balancer: Exchange Proxy 2
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5	8132	748	ENS: ETH Registrar Controller
0x4678f0a6958e4d2bc4f1baf7bc52e8f3564f3fe4	709	671	Maker: Proxy Registry
0xabea9132b05a70803a4e85094fd0e1800777fbef	1411	665	zkSync
0xac14864ce5a98af3248ffbf549441b04421247d3	3184	648	Stake DAO: xSDT Token
0xdef171fe48cf0115b1d80b88dc8eab59176fee57	5899	647	Paraswap Augustus v5
0x1111111254fb6c44bac0bed2854e76f90643097d	53262	593	1inch v4 Router
0xe295ad71242373c37c5fda7b57f26f9ea1088afe	619	578	1inch Exchange AIrdrop
0x7d655c57f71464b6f83811c55d84009cd9f5221c	1438	563	Gitcoin Bulk CHeckout
0x99c9fc46f92e8a1c0dec1b1747d010903e884be1	1018	554	Optimism Gateway
0xc2edad668740f1aa35e4d8f227fb8e17dca888cd	12027	550	SushiSwap: MasterChef LP Staking Pool
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7	3249	549	Curve.fi: DAI/USDC/USDT Pool
0xba12222222228d8ba445958a75a0704d566bf2c8	3420	541	Balancer Vault
0x1bd435f3c054b6e901b7b108a0ab7617c808677b	3410	507	ParaSwap P4
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	8626	497	Aave: Lending Pool V2
0x7f268357a8c2552623316e2562d90e642bb538e5	6511	496	Opensea Wyvern exchange v2

Open questions and ideas

New Holders/Users analysis and notifications

Should we show holdings evolution through time ? Or interactions through time ? Daily contract Usage

Stickyness and churn analysis ? Analyse how many addresses keep using the contract or churned ?

Add a User leader board ?

Should we perform the same analysis on only active addresses ? Or historical users ?

Should we try deducting timezones based on activity timestamp ?

For general contracts should we add a google analytics Integration ?

What other labels can we add ?

Should we tag tokens and contracts in different categories such as DEFI, P2E ... ?

What other data do you want to measure on your users/holders ?

Are True User balance in ERC20 and ERC721 Usefull ?

Should We add a community tool ? Could be used to find Addresses that belong to the same owner or that have same onchain behaviour ?

Registered ENS analysis, Scrap data about all addresses that have a registered ENS.